UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9SrW1ySnqCLaiA0T33gyLhfTWQpmAU+RfoZ2NxK++L8='
WHERE
key_id = 'be34ad6df0945a49e4b9d23955e92807ae475c5f4f71eb3ef3d9713bc8261744'
AND (
token = '9SrW1ySnqCLaiA0T33gyLhfTWQpmAU+RfoZ2NxK++L8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)