UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gVnYDRhb6i3ggYbcy+EOxj9BNOserjke+Rz6MCqFH9I='
WHERE
key_id = 'c82ac8cc003fcefa4f5b28d6b5570084a2606b30ce3981ff3e25b09ee574ee3d'
AND (
token = 'gVnYDRhb6i3ggYbcy+EOxj9BNOserjke+Rz6MCqFH9I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)