UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xp7Iuio+KF5djXV51n4mdevjWisMw4OzQlGyg+qtmsw='
WHERE
key_id = '9248f3347aa7e1e2fe055bb4121b529a3ac416bfaa7d5008b6d205d631e80db2'
AND (
token = 'xp7Iuio+KF5djXV51n4mdevjWisMw4OzQlGyg+qtmsw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)