UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V5oSwrIZwfgwVOgrLV1HEJcEs5gNAAYwRThSYWN11sk='
WHERE
key_id = '99c7b7b4252afd98b7ab0d63572e0b613ac9221db89aa608fa9fc88f8cc5292d'
AND (
token = 'V5oSwrIZwfgwVOgrLV1HEJcEs5gNAAYwRThSYWN11sk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)