UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3brWq1NfVYrkjwsy59ZgA2PbQ8mtti7mGnCIqu5dXms='
WHERE
key_id = '54ec1334590286a33861a777884a630b9e99e6fb346cc1d715b9344b104fca2c'
AND (
token = '3brWq1NfVYrkjwsy59ZgA2PbQ8mtti7mGnCIqu5dXms='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)