UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qBq196x8Qoub/9H4qfbaIZsPlDJ/FFZQAxJbKxkqGzI='
WHERE
key_id = 'd2e76119b20c9212f7846e59f00af9bafe52be209c4e68f0b64e949fe896ed38'
AND (
token = 'qBq196x8Qoub/9H4qfbaIZsPlDJ/FFZQAxJbKxkqGzI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)