UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P0f3vtB8nKQEQLI7kcMRkmliZbIUEmNtK5CtDhe/CRs='
WHERE
key_id = '78af9d012bece65472ae91aec72820b752bde1e99c8a6007e0a8a669dd4d130b'
AND (
token = 'P0f3vtB8nKQEQLI7kcMRkmliZbIUEmNtK5CtDhe/CRs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)