UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SpoRhvS6DI9w0Xe2FA5Di+BGQxzMBaD8zDwjI2eq8S4='
WHERE
key_id = '0e473dda2fbf69a270473675577857240b53691c97f7e789a4ded1e02f12d54f'
AND (
token = 'SpoRhvS6DI9w0Xe2FA5Di+BGQxzMBaD8zDwjI2eq8S4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)