UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RNkWATHtlj2xqcaAEpYAamwH1xRrO43LcnC9uKMNyio='
WHERE
key_id = 'e9fab26f8a6a72708c697891f535ce278819d0bb2e85f4c04fe175018483949a'
AND (
token = 'RNkWATHtlj2xqcaAEpYAamwH1xRrO43LcnC9uKMNyio='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)