UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QBTv5gG3tBAUdHt4FAMDPNzffI+PIOYP9UnuPeFDbYo='
WHERE
key_id = '9048868d6c234e37fe6a23166c6589ff8b1a76d767f119ac934fe9f2693c4f9f'
AND (
token = 'QBTv5gG3tBAUdHt4FAMDPNzffI+PIOYP9UnuPeFDbYo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)