UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vKMunj9YRvynAd3Myi3PGgm3z4Ou1nJcdeMdCb3mglU='
WHERE
key_id = '1ce411213d6fa1472a1198197868a5977bd8e4f679c81722fcf5489d4a96f71a'
AND (
token = 'vKMunj9YRvynAd3Myi3PGgm3z4Ou1nJcdeMdCb3mglU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)