UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I7foRBZk7XUZ4sw1k98HzR0z3FN8DAScmIDJlCKHvMY='
WHERE
key_id = '46ba24c79a842cb5a86afa5fb888d34f2a74f38fcaaca768cb300999c6fa0cf2'
AND (
token = 'I7foRBZk7XUZ4sw1k98HzR0z3FN8DAScmIDJlCKHvMY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)