UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cbA+HlHSS8VKs84ABPuHsLEDCzu+eLWxjnDqqPnZGR0='
WHERE
key_id = 'cac4c912d399813be3baceb40c1079b89a24f1100f201a0b9794637a3b89c907'
AND (
token = 'cbA+HlHSS8VKs84ABPuHsLEDCzu+eLWxjnDqqPnZGR0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)