UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BBSuptCFTWYVZyIsyIoJ/gEewJ1OUtzC2xJdXnNG5vU='
WHERE
key_id = 'ee187b9214c1845f0a9873f73d4583f99ce0d2972441f70c16218c673eae1164'
AND (
token = 'BBSuptCFTWYVZyIsyIoJ/gEewJ1OUtzC2xJdXnNG5vU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)