UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iIXVcHpO9BuWENQChzft0l8X1Hzi6dyKeh0706+Qg7c='
WHERE
key_id = 'aa94a0b630fa2a41314053f0b8b834600341a90eef18a6b96657c3ee5a59bbad'
AND (
token = 'iIXVcHpO9BuWENQChzft0l8X1Hzi6dyKeh0706+Qg7c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)