UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lIBOlbVSx+uuPokQLsOUIJoLNAkGqVDIZKEb2YmAxzw='
WHERE
key_id = '3f6527b055c90c0dd32f6d9da772fba1e4dab333eb480bc35d4bc4bdc25f03c0'
AND (
token = 'lIBOlbVSx+uuPokQLsOUIJoLNAkGqVDIZKEb2YmAxzw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)