UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nJ7D/nR+3lxqlL8YzdzWPhPchQKzCP35k/HZVrQ9Mhw='
WHERE
key_id = 'dccbad99b23a8db602b71159d9804f09db96cd1f3ea69424236bf11b614999e1'
AND (
token = 'nJ7D/nR+3lxqlL8YzdzWPhPchQKzCP35k/HZVrQ9Mhw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)