UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YCE3rzuGXg3MOfsTGrybCth2pAnOfFjaqgSFqWo16iE='
WHERE
key_id = '256f1fe43d4fafb83f2f68cf3aeefc09a91260f6ea01d13b92021657ee8de143'
AND (
token = 'YCE3rzuGXg3MOfsTGrybCth2pAnOfFjaqgSFqWo16iE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)