UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pwBTwLl7gO1QV9ELFRPx3o5lvvZsixHyq4b7PGpbyow='
WHERE
key_id = '8ae6f580265cc2ee2cc7383a40545a3933c2ce4548b831108f2e72eb9ba903cb'
AND (
token = 'pwBTwLl7gO1QV9ELFRPx3o5lvvZsixHyq4b7PGpbyow='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)