UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k+FObXxkjTgL448HsyAHkN9bR98DY3Q9La90Sx/rNeI='
WHERE
key_id = 'd818d40093578963d43d22c35b049d53cf4df76d55375ca1bf9aa31b15e94bcf'
AND (
token = 'k+FObXxkjTgL448HsyAHkN9bR98DY3Q9La90Sx/rNeI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)