UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sNHaX0zoCcVIQoMjQ0LT6yjbnRp9ERLOE3Xko4J5PlE='
WHERE
key_id = '04c8bfea62dae921f64aeeb6d935118f97740b9f6b8c535c9e9290e0d7fff75c'
AND (
token = 'sNHaX0zoCcVIQoMjQ0LT6yjbnRp9ERLOE3Xko4J5PlE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)