UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZVfquOJJwRgNf/9NCU/c8RpwKOcxARLxUDJD1zzeyTo='
WHERE
key_id = 'b031ff05875d4da6200ad435da28c42acf00ab1ffe2fd0ecd02826721d7fc4a2'
AND (
token = 'ZVfquOJJwRgNf/9NCU/c8RpwKOcxARLxUDJD1zzeyTo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)