UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J1jj2X1IXD1XGvJJEQ+4YFDof8pYiT1SbT4JruEwU0c='
WHERE
key_id = '6e1710b2123d0e11c0cb030b106ec99b9dd8a91eabc9ae4f987dfb43cd5f33c6'
AND (
token = 'J1jj2X1IXD1XGvJJEQ+4YFDof8pYiT1SbT4JruEwU0c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)