UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tPErEflvOhy3AUvJp01a9+cH9ReohJTPFjwNPIOA/Hc='
WHERE
key_id = 'e49de4316751d750747c0dd9f6b94c7b027177e95d76c3017cb9759b209a9bfa'
AND (
token = 'tPErEflvOhy3AUvJp01a9+cH9ReohJTPFjwNPIOA/Hc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)