UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BLnSd0228QDNEtTMa1kryPRu+ZanRwU/NVit0j0rrjs='
WHERE
key_id = '027c0c1e854b31a38970974c6e2446a153e698c56de444548eb8d5d3d4df0255'
AND (
token = 'BLnSd0228QDNEtTMa1kryPRu+ZanRwU/NVit0j0rrjs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)