UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XtC7reBPiSPdWRLFvNkDsUdXNGr3WpuwAEbQdTmcMEs='
WHERE
key_id = '0b11cfbbae268974274f135e96960f63e9db7fc16c2558486e823b0c7ab061f1'
AND (
token = 'XtC7reBPiSPdWRLFvNkDsUdXNGr3WpuwAEbQdTmcMEs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)