UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a/vQyhuPli9uV7kAHK1twBnTrsq52yMLDzBD1nawF+E='
WHERE
key_id = '4960ac9b882bb44906b01186d2776117c4b010e279c7f56537f426b9a5df635f'
AND (
token = 'a/vQyhuPli9uV7kAHK1twBnTrsq52yMLDzBD1nawF+E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)