UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YrnsT57AmWTS5cJOEPsTue5rKAkqg47MejkyVq5Nl/s='
WHERE
key_id = 'eef7c2e8d85f4b59089b3e352d279ce8e5387070dc9ffb22e6ebd91c9f5f49d0'
AND (
token = 'YrnsT57AmWTS5cJOEPsTue5rKAkqg47MejkyVq5Nl/s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)