UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pWIwc0wkI+H+NNFnih8isNbUhg97/L5V6i4JOsBkfbI='
WHERE
key_id = 'e332d077afa65122003ca0638b4daaefa09b67bfa537778984894c2ee692de7f'
AND (
token = 'pWIwc0wkI+H+NNFnih8isNbUhg97/L5V6i4JOsBkfbI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)