UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H8pw446HPg9iRU2Utx/QcibGU5Qf6/+b0VRGrnYYCYI='
WHERE
key_id = 'ff32b1bdd3d7cd32ce6842310ef5c231e810509c7bfa7f77c87c3d5bac9affd3'
AND (
token = 'H8pw446HPg9iRU2Utx/QcibGU5Qf6/+b0VRGrnYYCYI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)