UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V6Q16nEKNUELqffx7Km6ez5kuRYDO6ZDAwt2BMqxcL4='
WHERE
key_id = '5380166c853fce679f72143e27d534b42cea3c3ab952ecdc833314c19fe49422'
AND (
token = 'V6Q16nEKNUELqffx7Km6ez5kuRYDO6ZDAwt2BMqxcL4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)