UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'siy2eRXpwSsam9onKo9VaIz8nEHvTCSK/2wwwx7VEMA='
WHERE
key_id = '7e566e769484737b9b2bf4aa100ccecc44a63a4641f9c6a607dbfe3185366efc'
AND (
token = 'siy2eRXpwSsam9onKo9VaIz8nEHvTCSK/2wwwx7VEMA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)