UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nIvWNtaWanlxYSFK6UjB6+F7ErWQCM/U1mStyU1EVgE='
WHERE
key_id = '9a303722301b1945a133d89f0a477dda3c41fc60a34f32a5d9a97544f745c683'
AND (
token = 'nIvWNtaWanlxYSFK6UjB6+F7ErWQCM/U1mStyU1EVgE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)