UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uB0S4Jr9YAoP6+dTC/PTg/Nhihm4WaW/UuKtKKE7qmY='
WHERE
key_id = 'c9aa6f71994b47192de6513e9398b352ee97effd5f15150a66d1d0abc1077a4c'
AND (
token = 'uB0S4Jr9YAoP6+dTC/PTg/Nhihm4WaW/UuKtKKE7qmY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)