UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9XNWsZbiZ7cxaEcSb3M01SsRKHjLm3POieMzVQI5iF0='
WHERE
key_id = 'ba0c1c527e8c386557a7a0b1c56e31ff64ccaaf7c7740d084a74c6da8ec4f813'
AND (
token = '9XNWsZbiZ7cxaEcSb3M01SsRKHjLm3POieMzVQI5iF0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)