UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0UvE8Ob3AHRTcopTS1ddIn3oZ2FKlf1ARn82h1OqJlI='
WHERE
key_id = '2471ef6925048e45ee2f6b8102897a8450028b87d34e85b3a141c9bf93966743'
AND (
token = '0UvE8Ob3AHRTcopTS1ddIn3oZ2FKlf1ARn82h1OqJlI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)