UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '37pOp/uZV1WE3CNjbMj1Cprf5DYLRV8dXLWDNafAkrs='
WHERE
key_id = '0cf4853a74e028715335acbff706c158e08f04da36110ad65c1989c81b0eee8a'
AND (
token = '37pOp/uZV1WE3CNjbMj1Cprf5DYLRV8dXLWDNafAkrs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)