UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hW9WiXNUYdAC0HZ8Hk+BA33DFPA4a2iK50xoJrHWirY='
WHERE
key_id = '16271463fd01c107e24bc21ccde23f513975338b83bf6fcca4f25af3245b7f3b'
AND (
token = 'hW9WiXNUYdAC0HZ8Hk+BA33DFPA4a2iK50xoJrHWirY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)