UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qIfHfqzYRad1XKk0kvPRKF7CBW2XJvEicNV8i/8hymc='
WHERE
key_id = '20c9e4949e9e6443cb8805dd5ba53a9eee63b779ad31a1a275e640f304828ffa'
AND (
token = 'qIfHfqzYRad1XKk0kvPRKF7CBW2XJvEicNV8i/8hymc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)