UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+6mJiPPC1LUZei1J5T/SigjBeo7teniBkp4mr0el8cA='
WHERE
key_id = '4fe4f4a927efab0a84a237a1a71d1d251c13665b59a608ddae8665f27b0c268d'
AND (
token = '+6mJiPPC1LUZei1J5T/SigjBeo7teniBkp4mr0el8cA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)